# AWS-config
FORMAL_S3_CONFIG = {
    'access_key': 'AKIAWTBG3E42IMYODWHL',
    'secret_key': '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',
    'region_name': 'cn-northwest-1',
    'bucket': '',  # aws s3存储桶
    'filie_path': '',  # 线上文件夹（用来存放当前项目的文件）
    'file_size': 104857600  # 线上单个文件的大小（单位为字节）
}

# Mysql
mysqlhost = "prod-aurora-mysql.cluster-c4c25zx3njlu.rds.cn-northwest-1.amazonaws.com.cn"
user = "admin"
password = "pu2I05jiHUy48t8paK9W"
database = "fridge_bigdata"

sqlserver_host = "121.36.103.200"
sqlserver_user = "YTRjbOQC"
sqlserver_password = "OLYR68TgTqZY"
sqlserver_database = "db365"
sqlserver_port = 1433


mongo_map_table = "material_field_mapping_mongo"
hbase_map_table = "material_field_mapping"
material_table = "material"

ac365_mysqlhost = "deviceipp4-mysql-out.mymlsoft.com"
ac365_user = "elecard_readonly"
ac365_password = "zZ7iU3bI3kG6eH7j"




# Athena
db = 'original'
# fridge
fridge_target_table = "ods.iot_fridge"
fridge_target_table_hour = "ods.iot_fridge_hour"
fridge_mqtt_target_table = "ods.iot_fridge_mqtt"
fridge_mqtt_target_table_hour = "ods.iot_fridge_mqtt_hour"
fridge_hbase_table = 'original.fridge_http_hbase'
fridge_hbase_table_hour = 'original.fridge_http_hbase_hour'
fridge_history_table = 'original.fridge_history_http_tar'
fridge_mqtt_table = 'original.fridge_mqtt_hbase'
fridge_mqtt_table_hour = 'original.fridge_mqtt_hbase_hour'
# ac
ac_target_table = "ods.iot_ac"
ac_target_table_hour = "ods.iot_ac_hour"
ac_mqtt_target_table = "ods.iot_ac_mqtt"
ac_mqtt_target_table_hour = "ods.iot_ac_mqtt_hour"
ac_hbase_table = 'original.ac_http_hbase'  # ???
ac_hbase_table_hour = 'original.ac_http_hbase_hour'
ac_history_table = 'original.ac_history_http_tar'
ac_mqtt_table = 'original.ac_mqtt_pass_through'
ac_mqtt_table_hour = 'original.ac_mqtt_pass_through_hour'
# washer
washer_target_table = "ods.iot_washer"
washer_target_table_hour = "ods.iot_washer_hour"
washer_hbase_table = "original.washer_http_hbase"
washer_hbase_table_hour = "original.washer_http_hbase_hour"


OutputLocation = 's3://lambda-athena-log'

# ac365
ac365_location = "s3://original/ac_ac365_daily"
ac365_location_all = "s3://original/ac_ac365_all"

# firdge_history
# FRIDGE_START_YEAR = 2020
# FRIDGE_START_MONTH = 4
# FRIDGE_START_DAY = 3
#
# FRIDGE_END_YEAR = 2020
# FRIDGE_END_MONTH = 7
# FRIDGE_END_DAY = 7


FRIDGE_START_YEAR = 2022
FRIDGE_START_MONTH = 1
FRIDGE_START_DAY = 1

FRIDGE_END_YEAR = 2022
FRIDGE_END_MONTH = 1
FRIDGE_END_DAY = 12



# washer_history
WASHER_START_YEAR = 2022
WASHER_START_MONTH = 7
WASHER_START_DAY = 26

WASHER_END_YEAR = 2022
WASHER_END_MONTH = 8
WASHER_END_DAY = 7


# ac_history
AC_START_YEAR = 2022
AC_START_MONTH = 7
AC_START_DAY = 31

AC_END_YEAR = 2022
AC_END_MONTH = 8
AC_END_DAY = 2
AC_LINE_TIME = "2022-01-01"


